Problem Note 48297: An implicit pass-through query to Netezza does not appear when the SASTRACE= option is enabled
 |  |  |  |
When an implicit pass-through query is submitted to Netezza, the query might not appear in the log if the SASTRACE= option is enabled.
For example, you might use the following SASTRACE= option to see the SQL code that is being passed to the database:
options sastrace=',,,d' sastraceloc=saslog;
If your SAS® software is run in a UTF-8 session, it has to convert the SQL code to be passed to Netezza into UCS-2 Unicode. UCS-2 is a 2-byte Unicode, and, for most Latin characters, 1 of those bytes is NULL.
Then, when SAS tries to print out the implicit pass-through SQL, the NULL byte in the first UCS-2 character is interpreted as the NULL terminator, so only that character is printed.
In the trace, the message might appear as follows:
NETEZZA_1: Prepared: on connection 0
S
The S on the second line should be SELECT.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Netezza | Microsoft® Windows® for x64 | 9.3 TS1M1 | 9.4 TS1M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.3 TS1M1 | |||
| Microsoft Windows Server 2003 for x64 | 9.3 TS1M1 | |||
| Microsoft Windows Server 2008 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Microsoft Windows XP Professional | 9.3 TS1M1 | |||
| Windows 7 Enterprise 32 bit | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows 7 Ultimate x64 | 9.3 TS1M1 | 9.4 TS1M3 | ||
| Windows Vista | 9.3 TS1M1 | |||
| Windows Vista for x64 | 9.3 TS1M1 | |||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2014-08-29 16:29:38 |
| Date Created: | 2012-10-29 14:26:37 |